load data
characterset  UTF8 
append into table I_DPI_KPI
fields terminated by '|' 
TRAILING NULLCOLS (
                    
FLOWSEQUENCE   ,                       
EXPORTTIME "TO_DATE('1970-01-01','YYYY-MM-DD') + (:EXPORTTIME)/86400 + TO_NUMBER(SUBSTR(TZ_OFFSET(SESSIONTIMEZONE),1,3))/24",                       
DOMAINIP       ,                       
IPVERSION      ,                       
USERIP         ,                       
USERPORT       ,                       
USERBEGINPORT  ,                       
USERENDPORT    ,                       
SERVERIP       ,                       
SERVERPORT     ,                       
SERVERID       ,                       
APPID          ,                       
PROTOCOLTYPE   ,                       
STARTTIME "TO_DATE('1970-01-01','YYYY-MM-DD') + (:STARTTIME)/86400 + TO_NUMBER(SUBSTR(TZ_OFFSET(SESSIONTIMEZONE),1,3))/24",                          
ENDTIME   "TO_DATE('1970-01-01','YYYY-MM-DD') + (:ENDTIME)/86400 + TO_NUMBER(SUBSTR(TZ_OFFSET(SESSIONTIMEZONE),1,3))/24",                     
V1_1           ,                       
V1_2           ,                       
V1_3           ,                       
V1_4           ,                       
V1_5           ,                       
V1_6           ,                       
V1_7           ,                       
V1_8           ,                       
V1_9           ,                       
V1_10          ,                       
V1_11          ,                       
V1_12          ,                       
V2_1           ,                       
V2_2           ,                       
V2_3           ,                       
V2_4           ,                       
V2_5           ,                       
V2_6           ,                       
V2_7           ,                       
V2_8           ,                       
V2_9           ,                       
V2_10          ,                       
V2_11          ,                       
V2_12          ,                       
V3_1           ,                       
V3_2           ,                       
V3_3           ,                       
V3_4           ,                       
V3_5           ,                       
V3_6           ,                       
V3_7           ,                       
V3_8           ,                       
V3_9           ,                       
V3_10          ,                       
V3_11          ,                       
V3_12          ,                       
V4_1           ,                       
V4_2           ,                       
V4_3           ,                       
V4_4           ,                       
V4_5           ,                       
V4_6           ,                       
V4_7           ,                       
V4_8           ,                       
V4_9           ,                       
V4_10          ,                       
V4_11          ,                       
V4_12          ,                       
T1_1           ,                       
T1_2           ,                       
T1_3           ,                       
T1_4           ,                       
T1_5           ,                       
T1_6           ,                       
T1_7           ,                       
T1_8           ,                       
T1_9           ,                       
T1_10          ,                       
T1_11          ,                       
T1_12          ,                       
T2_1           ,                       
T2_2           ,                       
T2_3           ,                       
T2_4           ,                       
T2_5           ,                       
T2_6           ,                       
T2_7           ,                       
T2_8           ,                       
T2_9           ,                       
T2_10          ,                       
T2_11          ,                       
T2_12          ,                       
W1_1           ,                       
W1_2           ,                       
W1_3           ,                       
W1_4           ,                       
W1_5           ,                       
W1_6           ,                       
W1_7           ,                       
W1_8           ,                       
W1_9           ,                       
W1_10          ,                       
W1_11          ,                       
W1_12          ,                       
W2_1           ,                       
W2_2           ,                       
W2_3           ,                       
W2_4           ,                       
W2_5           ,                       
W2_6           ,                       
W2_7           ,                       
W2_8           ,                       
W2_9           ,                       
W2_10          ,                       
W2_11          ,                       
W2_12          ,                       
WT1_1          ,                       
WT1_2          ,                       
WT1_3          ,                       
WT1_4          ,                       
WT1_5          ,                       
WT1_6          ,                       
WT1_7          ,                       
WT1_8          ,                       
WT1_9          ,                       
WT1_10         ,                       
WT1_11         ,                       
WT1_12         ,                       
WT2_1          ,                       
WT2_2          ,                       
WT2_3          ,                       
WT2_4          ,                       
WT2_5          ,                       
WT2_6          ,                       
WT2_7          ,                       
WT2_8          ,                       
WT2_9          ,                       
WT2_10         ,                       
WT2_11         ,                       
WT2_12         ,                       
ST1_1          ,                       
ST1_2          ,                       
ST1_3          ,                       
ST1_4          ,                       
ST1_5          ,                       
ST1_6          ,                       
ST1_7          ,                       
ST1_8          ,                       
ST1_9          ,                       
ST1_10         ,                       
ST1_11         ,                       
ST1_12         ,                       
ST2_1          ,                       
ST2_2          ,                       
ST2_3          ,                       
ST2_4          ,                       
ST2_5          ,                       
ST2_6          ,                       
ST2_7          ,                       
ST2_8          ,                       
ST2_9          ,                       
ST2_10         ,                       
ST2_11         ,                       
ST2_12         ,                       
HT1_1          ,                       
HT1_2          ,                       
HT1_3          ,                       
HT1_4          ,                       
HT1_5          ,                       
HT1_6          ,                       
HT1_7          ,                       
HT1_8          ,                       
HT1_9          ,                       
HT1_10         ,                       
HT1_11         ,                       
HT1_12         ,                       
HT2_1          ,                       
HT2_2          ,                       
HT2_3          ,                       
HT2_4          ,                       
HT2_5          ,                       
HT2_6          ,                       
HT2_7          ,                       
HT2_8          ,                       
HT2_9          ,                       
HT2_10         ,                       
HT2_11         ,                       
HT2_12         ,                       
BN1_1          ,                       
BN1_2          ,                       
BN1_3          ,                       
BN1_4          ,                       
BN1_5          ,                       
BN1_6          ,                       
BN1_7          ,                       
BN1_8          ,                       
BN1_9          ,                       
BN1_10         ,                       
BN1_11         ,                       
BN1_12         ,                       
BF1_1          ,                       
BF1_2          ,                       
BF1_3          ,                       
BF1_4          ,                       
BF1_5          ,                       
BF1_6          ,                       
BF1_7          ,                       
BF1_8          ,                       
BF1_9          ,                       
BF1_10         ,                       
BF1_11         ,                       
BF1_12         ,                       
BN2_1          ,                       
BN2_2          ,                       
BN2_3          ,                       
BN2_4          ,                       
BN2_5          ,                       
BN2_6          ,                       
BN2_7          ,                       
BN2_8          ,                       
BN2_9          ,                       
BN2_10         ,                       
BN2_11         ,                       
BN2_12         ,                       
BF2_1          ,                       
BF2_2          ,                       
BF2_3          ,                       
BF2_4          ,                       
BF2_5          ,                       
BF2_6          ,                       
BF2_7          ,                       
BF2_8          ,                       
BF2_9          ,                       
BF2_10         ,                       
BF2_11         ,                       
BF2_12         ,                       
CN1_1          ,                       
CN1_2          ,                       
CN1_3          ,                       
CN1_4          ,                       
CN1_5          ,                       
CN1_6          ,                       
CN1_7          ,                       
CN1_8          ,                       
CN1_9          ,                       
CN1_10         ,                       
CN1_11         ,                       
CN1_12         ,                       
CF1_1          ,                       
CF1_2          ,                       
CF1_3          ,                       
CF1_4          ,                       
CF1_5          ,                       
CF1_6          ,                       
CF1_7          ,                       
CF1_8          ,                       
CF1_9          ,                       
CF1_10         ,                       
CF1_11         ,                       
CF1_12         ,                       
CN2_1          ,                       
CN2_2          ,                       
CN2_3          ,                       
CN2_4          ,                       
CN2_5          ,                       
CN2_6          ,                       
CN2_7          ,                       
CN2_8          ,                       
CN2_9          ,                       
CN2_10         ,                       
CN2_11         ,                       
CN2_12         ,                       
CF2_1          ,                       
CF2_2          ,                       
CF2_3          ,                       
CF2_4          ,                       
CF2_5          ,                       
CF2_6          ,                       
CF2_7          ,                       
CF2_8          ,                       
CF2_9          ,                       
CF2_10         ,                       
CF2_11         ,                       
CF2_12         ,                       
TH1_1          ,                       
TH1_2          ,                       
TH1_3          ,                       
TH1_4          ,                       
TH1_5          ,                       
TH1_6          ,                       
TH1_7          ,                       
TH1_8          ,                       
TH1_9          ,                       
TH1_10         ,                       
TH1_11         ,                       
TH1_12         ,
BATCHTIMESTAMP  EXPRESSION "TO_DATE('2013-11-11 12:12:12','YYYY-MM-DD HH24:MI:SS')"     
)

--sqlldr userid=IOSSDEV/OBASDEV@DB control='D:\repository\workspaces\ioss_googlecode_java\com.obas.network.java.impl\src\com\obas\integration\dpi\service\impl\dpi.kpi.ctl' data='D:\solution\ioss_yunnantelecom\integration_dpi\DATA\20130705_1749\KPI_20130705_1749.txt' log='D:\solution\ioss_yunnantelecom\integration_dpi\DATA\20130705_1749\KPI_20130705_1749.log' parallel=true rows=5000 bindsize=10485760
